Previous Topic

Next Topic

Activity Attachment Fields

To support the activity attachment feature, the following fields in the Activity_Attach table are used:

Column Name

Data Type/Size

Description

ACTIVITY_SEQN

long integer

Used to store a reference to an associated activity record

FILE_NAME

varchar (255)

Attachment's file extension

FILE_TIMESTAMP

Datetime

Date the attachment was last modified

ATTACH_IMAGE

image

File's binary data

INTENT_TO_EDIT

varchar (40)

Indicates whether a user has started an edit operation (Date/Time + "#" + <User ID>)

READ_ONLY

Boolean

Indicates whether the attachment is available for editing by non-administrator users

See Also

Activity Attachments

To enable the activity attachment feature

Specifying maximum size of activity attachments

To purge activity attachments created before a specified date


ASI logo 10.6 Production Release. Updated 1/18/2006 3:50:35 PM
© Copyright by Advanced Solutions International, Inc. All rights reserved.